SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
-- Pointer used for text / image updates. This might not be needed, but is declared here just in case
DECLARE @ptrval binary(16)

BEGIN TRANSACTION

-- Add 2 rows to int_value
INSERT INTO [dbo].[int_value] ([longdesc], [int_name], [int_value], [shortdesc]) VALUES (N'iv_formtype', N'Form', 1, N'Form')
INSERT INTO [dbo].[int_value] ([longdesc], [int_name], [int_value], [shortdesc]) VALUES (N'iv_formtype', N'Survey', 2, N'Survey') 

-- Add 6 rows to form_controls
INSERT INTO form_controls ([FormControlID] ,[ControlType] ,[Control] ,[ControlName] ,[RequiresRows] ,[RequiresColumns]) VALUES ('6C6DDB9F-8702-428F-A40D-FFBDA7D80EE0', 1, 'TextBox', 'Single TextBox', 0, 0)
INSERT INTO form_controls ([FormControlID] ,[ControlType] ,[Control] ,[ControlName] ,[RequiresRows] ,[RequiresColumns]) VALUES ('976B6515-8497-4C90-8C54-8EDC82D86343', 2, 'TextBox', 'Multiple Line TexBox', 0, 0)
INSERT INTO form_controls ([FormControlID] ,[ControlType] ,[Control] ,[ControlName] ,[RequiresRows] ,[RequiresColumns]) VALUES ('FDBAC0EB-C7F6-4E6F-9214-68CEEE8F078F', 3, 'DropDownList', 'Selection List', 0, 0)
INSERT INTO form_controls ([FormControlID] ,[ControlType] ,[Control] ,[ControlName] ,[RequiresRows] ,[RequiresColumns]) VALUES ('2EE4AE82-FE97-44F2-87E6-2750A8F808E5', 4, 'TextBox', 'Date/Time', 0, 0)
INSERT INTO form_controls ([FormControlID] ,[ControlType] ,[Control] ,[ControlName] ,[RequiresRows] ,[RequiresColumns]) VALUES ('87B3B7C9-1B76-49AA-9731-F944D0FEDAAA', 5, 'RadioButtonList', 'Multiple Choice, Single Answer', 1, 0)
INSERT INTO form_controls ([FormControlID] ,[ControlType] ,[Control] ,[ControlName] ,[RequiresRows] ,[RequiresColumns]) VALUES ('EB5D3D5E-34A3-4D89-908D-D135742DB131', 6, 'CheckBoxList', 'Multiple Choice, Multiple Answer', 1, 0)
INSERT INTO form_controls ([FormControlID] ,[ControlType] ,[Control] ,[ControlName] ,[RequiresRows] ,[RequiresColumns]) VALUES ('371B8D31-767B-4DA3-9201-FBABD6BE5CC1', 7, 'RadioButtonList', 'Matrix - One Answer Per Row', 1, 1)
INSERT INTO form_controls ([FormControlID] ,[ControlType] ,[Control] ,[ControlName] ,[RequiresRows] ,[RequiresColumns]) VALUES ('DB948EDA-BC53-4CDD-A809-9CCBD16772DE', 8, 'CheckBoxList', 'Matrix - Multiple Answers Per Row', 1, 1)

-- Add 2 rows to themes
INSERT INTO [dbo].[themes] ([themeid], [themename], [themefolder], [usagecount], [archived]) VALUES ('02f74b7c-7b5b-4e5f-b573-fce648fdd507', N'Dark Blue', N'DarkBlue', 0, 0)
INSERT INTO [dbo].[themes] ([themeid], [themename], [themefolder], [usagecount], [archived]) VALUES ('3fe9b828-f272-4a80-ab28-707898ca2a04', N'Dark Grey', N'DarkGrey', 0, 0)

-- Add 1 row to aspnet_roles
INSERT INTO [dbo].[aspnet_Roles] ([RoleId], [ApplicationId], [RoleName], [LoweredRoleName], [Description]) VALUES ('AF07E0C3-6F33-4531-B824-D830E270F052', '0792e47b-d71e-4de5-ab55-37201f8fb56e', N'Banned', N'banned', NULL)

-- Add 1 row to [dbo].[DBVersion]
INSERT INTO [dbo].[DBVersion] ([version], [installdate]) VALUES (1.5, getdate())

COMMIT TRANSACTION
